To Import Data
1. Open the File menu and choose Import.
The File Import window appears.
2. In the Import Type option box a number of different data types are listed. Select one of these data types to be imported.
3. To import the data click Run. If you want to exit from the importing procedure, click Close.
4. When you click Run the Open window appears for you to indicate the source of the data.
Files for import must have the file extension .CSV. Once you have selected the source file, to import the data into Sage Line 50, click OK.
The importing procedure is completed in two stages. Firstly, the source file is checked to ensure that the data is in the correct format. Secondly, if no errors are discovered, the data is imported and posted into the appropriate data files in Sage Line 50. To exit, click Close.
When the data has finished importing, if the import was successful the File Import Success window appears. This window reports on all the data that was imported, and records the data reference; the account/customer/supplier/product code and the narrative details of the data.
If there were problems that meant the data import was unsuccessful then the File Import Errors window appears. The window reports the errors in the data that caused the import to abort. The line in the data file where the error occurred is recorded, along with the field and the nature of the error. For example, if you received the error message:
Error in line 4, field 1 : Invalid data for Sales Ledger Account Reference field
This message indicates that in line 4, field 1 of the particular file you attempted to import, there was not a valid sales ledger account code.
Your next step...
Related Topics